/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.zjdt.epserver.servlet.util;

import com.zjdt.epserver.db.service4mysql.CargoServiceImpl;
import java.io.File;
import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.dusin.util.DateUtil;
import org.dusin.util.ExcelUtil;
import org.springframework.context.ApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;

/**
 *
 * @author dusin
 */
@WebServlet(name = "ExcelFileCreate", urlPatterns = {"/servlet/util/ExcelFileCreate"})
public class ExcelFileCreate extends HttpServlet {

    private CargoServiceImpl instance;

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
     * methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/json;charset=UTF-8");
        
        String fileName = "导出数据";//设置导出的文件名称        
        //PrintWriter out = response.getWriter();
        OutputStream out = response.getOutputStream();
        try {

            String basePath = "D:/template";
           ApplicationContext context = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
            instance = (CargoServiceImpl) context.getBean("cargoService");
            String companyCode = request.getParameter("companyCode");
            String factoryCode = request.getParameter("factoryCode");
            String dateFrom = request.getParameter("dateFrom");
            String dateTo= request.getParameter("dateTo");            
            String key = request.getParameter("searchKey");
            int page;
            int rows;
            try{
                page = Integer.parseInt(request.getParameter("page"));
                rows = Integer.parseInt(request.getParameter("rows"));
            }catch(NumberFormatException nfe){
                page = 1;
                rows = 20;
            }            
            page = 1;
            rows = 10000;  //导出不需要分页，所有设置很大的值
            List<Map<String, Object>> cargos=instance.findAll(null,companyCode,factoryCode,dateFrom,dateTo,key,(page-1)*rows,rows);
            int i=1;
            for(Map<String,Object> map:cargos){
                map.put("RN", i++);
            }
            fileName = "业务记录" + DateUtil.get(new Date(), "yyyyMMddHHmmss");
            int startRow = 3;
            int startCol = 0;           
            
            String[] fields = new String[]{"RN", "recordNo",  "arrivalTime","factoryName", "plateNo",
                "productName", "grossWeight","tareWeight","minusImpurity","netWeight","companyName",
                "siterName", "frontPhoto",
                "sidephoto", "licensePhoto","paperPhoto"};
            String templateFile = basePath + "/business.xls";

            response.resetBuffer();          //利用输出输入流导出文件             
            String contentType = "application/vnd.ms-excel";//定义导出文件的格式的字符串
            fileName = fileName + ".xls";
            String recommendedName = new String(fileName.getBytes(), "iso_8859_1");//设置文件名称的编码格式
            response.setContentType(contentType);//设置导出文件格式
            response.setHeader("Content-Disposition", "attachment; filename=\"" + recommendedName + "\"");//        
            new ExcelUtil().getExcelFileFromTemplate(cargos, fields, out, templateFile, startRow, startCol);
            out.flush();
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            out.close();
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}
